searching particular id in entire all tables

[stonecold111]

hi Qlikss

i have 10 tables in my data model.

all tables have common field   "ID"

all tables joined by common filed "ID"

i have a particular ID number= 200-34-22

i want to know from which table this ID loaded

i can go to Table Viewer and check each and every table by previewing it, but i want any easy solution as my tables are large.

suggest qlikss..

[hector_munoz]

Hi Suresh,

If you create in every of the 10 tables a field like [Origin TableX] with a value like "Table X" (where X is a value among 1 and 10), you could have a multibox with those 10 new fields and when you select an ID you would see in which tables is this ID present as their fields in the multibox will have a value.

Regards,
H

[hector_munoz]

I attach a sample...

Hope it serves!

Regards,
H

[stonecold111]

no i don't want to create any field

any other suggestions

[vishsaggi]

Without giving an identifier, how can you say which ID is coming from Which table. As Hector suggested, just create a flag in each table would be the better option i believe. Just create like

Tab1:

LOAD *,

          1 AS Tab1

FROM YoursourcepathFile;

Tab2:

LOAD *,

          2 AS Tab2

FROM YoursourcepathFile;

:

:

Tab10:

[stonecold111]

Yes . i know this way. but this is not my practice QVW.

This is project. i can't make changes lik that

anyway thanks

[hector_munoz]

Hi Suresh,

An alternative is, instead of creating a new field for each table, using in the multibox an existing field of every table that always is populated with data. When a user selects an ID, only those fields which belong to related tables would appear with a value.

Regards,

H

[vishsaggi]

What is your expected output should be like, What is that you want to see and Where?

[stonecold111]

Actually we are getting wrong values for that particular Id

i want to know to from which table this id is coming and test it as so many tables are there in data model

[stonecold111]

i mean ytd qtd calculation are getting wrong