topic Re: PROBLEM: Loading by using "Fixed Record" and "Enable Transformation Step" in QlikView

PROBLEM: Loading by using "Fixed Record" and "Enable Transformation Step"

Anonymous — Fri, 28 Sep 2012 02:49:05 GMT

Hi all,

I am having problem in loading a text file by using "fixed record" as the file type, I am able to load the data without getting any error.

However, problem comes up when I apply "enable transformation steps" at the same time, the system shows the "field not found" error when I apply

"enable transformation steps" while loading the data by using "fixed record" as the file type.

Anyone has solution for this issue?

Please find the attached for my script and sample text file.

Thanks.

Re: PROBLEM: Loading by using "Fixed Record" and "Enable Transformation Step"

Fri, 28 Sep 2012 03:05:24 GMT

Hi,

I have tried uploading your file as "fixed record" and enabled transformation steps. I didn't had an error. Could you attach some screenshots of the error?

Regards,

Janzen

Re: PROBLEM: Loading by using "Fixed Record" and "Enable Transformation Step"

Anonymous — Fri, 28 Sep 2012 03:14:00 GMT

Hi Janzen,

Thanks for your effort to try.

Below is the screenshot of the error that I got.

Thanks,

Tiong

Re: PROBLEM: Loading by using "Fixed Record" and "Enable Transformation Step"

Fri, 28 Sep 2012 03:23:08 GMT

Hi,

May I ask where did you get this line?

"filters(Remove(Row, Pos(Top,2)))"

Did you add any steps after setting header to 2 lines?

Regards,

Janzen

Re: PROBLEM: Loading by using "Fixed Record" and "Enable Transformation Step"

Anonymous — Fri, 28 Sep 2012 03:30:50 GMT

Hi,

Yes, after setting header to 2 lines, I clicked next button and enabled the transformation steps from the page as the screenshot shown below, thats where I got the line "filters(Remove(Row, Pos(Top,2)))".

Thanks,

Tiong

Re: PROBLEM: Loading by using "Fixed Record" and "Enable Transformation Step"

Fri, 28 Sep 2012 03:39:30 GMT

Hi,

After clicking Enable Transformation Steps, what did you do next? If you dont need to transform, you can just click next to proceed.

Regards,

Janzen

Re: PROBLEM: Loading by using "Fixed Record" and "Enable Transformation Step"

Anonymous — Fri, 28 Sep 2012 04:02:11 GMT

Hi,

Yes, I did some transformation steps to remove the row with "+++++++" characters, but it is so much more complicated in actual situation so I cannot avoid using transformation steps.

Thanks,

Tiong

Re: PROBLEM: Loading by using "Fixed Record" and "Enable Transformation Step"

Thu, 07 Feb 2013 06:49:00 GMT

Did you found a solution? I've the exactly same problem.

Re: PROBLEM: Loading by using "Fixed Record" and "Enable Transformation Step"

Anonymous — Thu, 07 Feb 2013 16:52:30 GMT

Hi Shellmann,

No I haven't, I did it with a workaround which I load the data first by using "Fixed Record" and store the table into qvd and then I load the data back from the qvd and perform the transformation step there.

Re: PROBLEM: Loading by using "Fixed Record" and "Enable Transformation Step"

Fri, 12 Jul 2013 02:02:48 GMT

Hi Jitiong Chua,

I'm having the same issue. I'll try the QVD intermediary step. Thanks for suggesting that.

Regards,