topic Re: Variables in Load Statement in QlikView

Variables in Load Statement

Anonymous — Wed, 29 May 2013 14:25:08 GMT

Hi,

We have data in the below format that needs to be loaded in qlikview

list of activities done by the user (each activity is in separate line)

Example:

05282013020030 userid

activity1

activity2

and so on

The same data gets repeated for all the users.

Now I have to load the data in such a way that the timestamp and the user id gets appened in front of each activity.

Is there any way to save the userid and timestamp in a variable inside the load statement?

I am relatively new to qlikview.

Thank you

Vinoth

Wed, 29 May 2013 14:33:34 GMT

Hi,

You can send a sample file??

Rebeca

Anonymous — Wed, 29 May 2013 14:41:13 GMT

Thanks for the quick response

I cannot upload a sample file as it is blocked in our environment

I am typing some sample statements below

Commit ts="20130430112926" client="USERNAME"

"View has been updated"

"Process has been executed"

"Test Chore was deleted"

Commit ts="20130432112926" client="USERNAME"

"Chore has been executed"

"Process has been executed"

and so on