split 1 row into 2 based on a value

Hi arti_r

You can create two new columns called Business Unit 1 and Business Unit 2 and split the [USD_AMT] in between them. Although that implies that the columns that don't need to be splitted are going to somehow be splitted too ....

If that's OK for you ...

1.- Open the quety editor.
2.- Add a new personalized column called "Business Unit 1".

3.- Write the following code
    

      if [LOCATION_CODE] = "750" then [USD_AMT] * 0.5 else [USD_AMT]

(you can change 0.5 for any other percentage if the split is not equal)

4.- Add a new personalized column called "Business Unit 2".

5.- Write the following code
    

      if [LOCATION_CODE] = "750" then [USD_AMT] * 0.5 else null

6.- Apply the necessary data type transformation
7.- Close & Load

If you do this process you'll end up with a 'Business Unit 1' column with the splitted data for Business Unit 1 AND the not splitted data, and a 'Business Unit 2' column with only the Business 2 splitted data.

Hope that Helps

Vicente