Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Not applicable

Multiple Columns Amalgamation

HI,

I have a source excel sheet that I am trying to pull out the Part numbers from.

Problem is there are 6 columns , Part Number 1, Part number2 etc all on the same row the same with part Qty.

I want to take the information out of all 6 rows and be able to report how many times we have used the part in Qlik sense

Any Ideas gratefully received!

3 Replies
sunny_talwar
Not applicable

Re: Multiple Columns Amalgamation

May be this can help:

The Crosstable Load

Not applicable

Re: Multiple Columns Amalgamation

Thanks Sunny this looks like it is what I need but has given me a couple more questions,

There are many other columns in the table, does this just take the fields I pick but still link to the other data?

Doe this have to be done at the data load or can it be put in as an expression?

mov
Not applicable

Re: Multiple Columns Amalgamation

I'm not Sunny, but I'l try to help
If you have multiple columns and want to keep some but transform the others using crosstable, you have to keep the columns "Part Number x" at the end.  And, in the corosstable use the number of the fields that should not be transformed:
crosstable (field1, field2, N).