Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Variables in Load Statement

Hi,

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

<timestamp and user info>

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

2 Replies
Not applicable
Author

Hi,

You can send a sample file??

Rebeca

Anonymous
Not applicable
Author

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