Creation of unique identifier

[#1]

Hi al

How to create a unique identifier

[jonathandienst]

Hi

I think your question is a bit vague. You will get more help if you provide some more details about your model structure.

Do you have a unique key of some sort in your source data?

Are you looking at adding a unique key during load? You can use RowNo() to do this

Do you want a GUID? I dont think QV can generate GUIDs.

Jonathan

[#3]

Hi Jonathan, As part of below requirement i have to create unique identifier.

I have a requirement like i have the data in spread sheet which i download from the website(on any day) and manually i have to add the filed " download date".

So the data fields are like download date,sr no,logged date, entry#, total amout etcc...

The requirement is the data which we have to download from the website is change at any time.Here we have to compare the data between the first time downloaded spread sheet and next time downloaded spread sheet as a weekly basis.

Eg: download date   sr no     logged date    entry#    total amount

      04/07/13              101     28/06/13        100098    600000                                   total records we have is 1001

2nd downloaded spread sheet

download date   sr no	logged date	entry#	total amount
01/07/13	101	28/06/13	100098	600000	total records we have is 1020

Note : the thing is columns are same in both the times but only rows will change.We have to compare the changes week by week.

Let me know if in case of any concerns in this regard.

Thanks in advance,

Ravi Teja

[jonathandienst]

It sounds to me like you need to add the QV reload time to your data set. You can use the Today(1) only if the reload only happens once per day, or Now(1) if it happens more often.

For example:

LOAD [download date],

     Now(1) as [reload time],

     [sr no],

     [logged date],

     [entry#],

     [total amount]

From ....

Jonathan

[#5]

Thnaks Jonathan..

Could please help me how we can compare the previously reloaded spread sheet data with new coming spread sheet on weekly basis. For the new spread sheets the columns are same only the records/values will change.

How we have to capture the changes of spread sheet2.

Could you please eloborate in detail.

Thnaks,

Ravi Teja