Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want transpose the table's column into separate entries?
for ex.
Perm ID | Code | Count | Code | Count |
abc | kyubis1 | 24 | kyubis2 | 33 |
def | kyubij1 | 19 | krsfgd2 | 46 |
Can i convert this to :
Perm ID | Code | Count |
abc | kyubis1 | 24 |
abc | kyubis2 |
33 |
def | kyubij1 |
19 |
def | krsfgd2 |
46 |
just to have separate and distinct data instead of horizontal repeatation.
Please help
Hi, the first table has some columns with the same name, I don't know how you can refer to the second 'Code' column. I think your real data might be different and it will be better to have an example of that real structure example.
If it helps: to split a row with separators in different rows you can use subfield() fucntion with only the 2 first parameters. (2nd example here)
There is also the option to load using crosstable
Hi, for the second parameter of subfield you can use Chr() and set the code for RS and GS, maybe you need to do it in some steps: first to split each pair, and a second one to split each pair value.
Pfa for the actual text file. @rubenmarin @jonashertz …in this as you see, RS and GS prefix data gets populated horizontally..I required only count and code column for all such entries.
Hi, it will be better if you attach some sample data in a format that we can test to load in Qlik.