This content has been marked as final. Show 5 replies
could anyone help me in this?
I've to get multiple values from a .dat file in which any record has a filed containing 4 values (sub-fields), separated by a pipe ('|'); any value can have 1, 2 or more characters; for example:
record 1, field 1 - xxxxx|0|12|2|453|xxxxxxx
record 2, field 1 - xxxxx|23|401|2|121|xxxxxx
Any value between pipes have to become a field in Qlik (value1, value2, value3, value4).
Which is the best way to solve this?
Thanks in advance,