topic Importing text file problem in QlikView

Importing text file problem

sbrites21 — Fri, 18 Jun 2021 11:43:29 GMT

Hello Qlik Community,

I'm having a problem importing a text file to qlikview.

I need to import the file as

Stop Val1 Val2 Val3 Val4 ...

Any help would be grateful.

Thank you,

Sérgio Brites

sergio0592 — Fri, 18 Jun 2021 14:47:21 GMT

Hi,

Did you try to import your .txt file with using Menu in Edit script ?

sbrites21 — Fri, 18 Jun 2021 15:51:38 GMT

Hello,

Yes i did.

Some lines are ok, but others aren't.

For those lines, I need to concatenate the columns with the names and shift left the columns with the numbers.

You can check the attachment.

Thank you.

Sérgio