Mapping - help

[#1]

Hi

Please find attached excel file.

BOOKING and CATEGORY are tables. CATEGORY NAME & SALES are Columns (highlighted in red colour).

I want to see CATEGORY NAME wise SALES. But there is no relationship ( or common key) between tables.

How can I MAP the fields ?

Can anybody help me out ??

Many thanks

[#2]

I think you should use intervalmatch().

[#3]

Hi Muncho

Thanks for your reply.

Can you explain me how to use INTERVAL MATCH () in script ?

Syntax please ?

Many thanks

[Miguel_Angel_Baeyens · Accepted solution]

Hello,

Is there a correspondence line to line for each table (sheet)? If that's the case, you can load both tables separately and create a new field in both

RowNo() AS Record_No

So line 1 in table "booking" corresponds to line 1 in table "category".

Hope that helps.

[#5]

Hi miguel

Thanks for your reply .

Miguel Angel Baeyens wrote:
Is there a correspondence line to line for each table (sheet)?

No Correspondence for each table.

How to link them ??

Many thanks

[Miguel_Angel_Baeyens]

puli.prakash83 wrote:No Correspondence for each table.
How to link them ??

It's something it's very difficult (if not impossible) to say. Not knowing the datamodel, it is something that has nothing to do with QlikView rather than the analyses required and the information where they com from. If there is no way to link two tables, then it's not possible to make analysis between them.

You need to find some criteria so you can associate one way or another what fields from one table can be linked to the other table.

Regards.

[#7]

Hi Miguel

Sorry from my side. I have checked again and find out there is a correspondence line to line for each table. Then I tried your solution …..rowno() as record_no… in each load. That's working great. I have got perfect results.

Thanks a lot miguel….