Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Can we use Rowno() as LInking in Datamodel..?

Hi All,

can we make use of ROWNO() as a Linking Key in the Datamodel..?

Your Help Appreciated..

Thanks,

Mohan

1 Solution

Accepted Solutions

Re: Can we use Rowno() as LInking in Datamodel..?

Technically yes, loading RowNo() as Key, but you will get wrong associations if sequence or number of records in your tables change.

4 Replies

Re: Can we use Rowno() as LInking in Datamodel..?

Technically yes, loading RowNo() as Key, but you will get wrong associations if sequence or number of records in your tables change.

Not applicable

Re: Can we use Rowno() as LInking in Datamodel..?

Hi Macro,

Thanks for your Reply, but could you please look into my scenario below..

1)..I have created RowNo() as KEY in one of my Table..

let me call the Table name as Test_Table, in this table i have created the KEY from ROWNO() function.

2).. Am doing the RESIDENT LOAD of the same Test_Table again. naming this as Table_2

so link between the two tables is KEY(generated from ROWNO() function).

will it impact..?

Thanks,

Mohan

Re: Can we use Rowno() as LInking in Datamodel..?

As long as you don't recalculate the RowNo() as Key in the second (resident) load, this should work (sorting or filtering with where clause could mix the associations up).

Maybe you could evaluate the Autonumber, AutonumberHash128 (or 256) if there are combined field combinations that might serve as a key as well. This could look like:

LOAD field1,

          field2,

          field3,

          ...

          AutonumberHash128(Field1, Field2, Field3) as Key

FROM yoursource;

hope this helps

regards

Marco

Not applicable

Re: Can we use Rowno() as LInking in Datamodel..?

Marco, Thanks a lot for your time.

I have already used the Autonumber().

Here in my current data, couldnt make out the Unique Fields.. Thats the reason am approaching this way.

Regards,

Mohan

Community Browser