Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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

May be this can help:

The Crosstable Load

Not applicable
Author

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?

Anonymous
Not applicable
Author

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).