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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
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