Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
You can send a sample file??
Rebeca
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