topic Re: move data in QlikView

move data

soniasweety — Fri, 15 Nov 2024 23:57:50 GMT

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?

Re: move data

tresB — Thu, 17 Sep 2020 07:46:57 GMT

@soniasweety

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

Re: move data

soniasweety — Thu, 17 Sep 2020 07:49:27 GMT

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

Re: move data

tresB — Thu, 17 Sep 2020 07:50:20 GMT

@soniasweety

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

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

Re: move data

soniasweety — Thu, 17 Sep 2020 07:59:11 GMT

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

Re: move data

tresB — Thu, 17 Sep 2020 08:07:01 GMT

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

Load

....,

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

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

Re: move data

soniasweety — Thu, 17 Sep 2020 08:14:49 GMT

not working

Re: move data

tresB — Thu, 17 Sep 2020 09:46:21 GMT

@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

Re: move data

soniasweety — Thu, 17 Sep 2020 15:38:58 GMT

thanks alot it works. @tresB @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)