move data

[soniasweety]

hi all, tresesco

i  have two columns 

Product (coulmn1)

flipkart

ebay

paytm

Source(Coulmn2) 

amazon

so now my requirement is  ... in coumn1  only flipkart should move to  column2 ..  

how can i get only flipkart into source column?

[tresesco · Accepted solution]

@soniasweety 

May be using calculated dimension, like: If(Product='flipkart', Product) and then enable Null suppress for this dimension.

[soniasweety]

if i use  above your condition.. flipkart will not appear in source filed right?

i want in script  .. how can i use?

my result should be

Product (coulmn1)

ebay

paytm

Source(column2)

Amazon

Flipkart

[tresesco]

@soniasweety 

If you are looking to filter the data, try something like:

Load ..... From <> Where Product='flipkart' ;

[soniasweety]

sorry 😞  i want to move value in one column to other column..   

filkart value should appear in source coulmn along with amazon  now it is in product column

[tresesco]

If there are no other dependencies, you could try like:

Load

          ....,

          If(Product='Flipkart', 'Flipkart')   as Source,

          If(Product='Flipkart', null())   as Product    

[soniasweety]

not working 

[tresesco · Accepted solution]

@soniasweety 

Well, you need to include the else part as well, like:

Load

          ....,

          If(Product='Flipkart', 'Flipkart', Source)   as Source,

          If(Product='Flipkart', null(), Product)   as Product  

[soniasweety]

thanks alot it works.  @tresesco   @sunny_talwar  @Kushal_Chawda 

but i have other case for one more user. 

i want to create new column   

Result_column  

Amazon

*FLIPKART*   ( means all wildmatch data for flipkart)