Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
Im trying to load an excel spreadsheet with data but need to transpose some of columns so I get a really simple table in qlik, is this possible?
Excel Input | |||||||
Field 1 | Field 2 | Field 3 | Jan | Feb | Mar | Apr | |
a | d | g | 1 | 2 | 5 | 1 | |
b | e | h | 7 | 3 | 2 | 4 | |
c | f | i | 4 | 8 | 2 | 4 | |
Qlik Table | |||||||
Field 1 | |||||||
Field 2 | |||||||
Field 3 | |||||||
Months |
Thanks in advance
Try using Crosstable()
CrossTable(Month, Value,3)
LOAD * Inline [
Field 1,Field 2,Field 3,Jan,Feb,Mar,Apr
a, d, g, 1, 2, 5, 1
b, e, h, 7, 3, 2, 4
c, f, i, 4, 8, 2, 4]
;
Try using Crosstable()
CrossTable(Month, Value,3)
LOAD * Inline [
Field 1,Field 2,Field 3,Jan,Feb,Mar,Apr
a, d, g, 1, 2, 5, 1
b, e, h, 7, 3, 2, 4
c, f, i, 4, 8, 2, 4]
;
Briiliant, really helpful. Is there anyway I can change the month field as its pulling through as a numberic field?
I'm sorry, but I don't really understand your issue. Could you try to post a picture or explain again in other words?