Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have two tables.
In one table i have A,B,C,D.....K
In second table i have A,B,C,D,L.
Now i need to use combination of A,b,C,D(from 1st table if i don't use A,B,C,D from second table also fine) to get the value for L which is in second table.
Now for this what i need to do join or link the tables or Mapping.. I am not sure.
Can you please help me on this.
Thanks,
Bharat
No Same category field is missing...
this is before refresh.. he asked me to comment my code then refresh with his code.. after refresh i got the below one:
I have changed code
PFA
Thanks a lot.... Thank you so much.
1)Can you tell me about autonumber why u have used
2) what gives for this one ApplyMap('Final_Category',Key,'Nodata') as Category like what s key and nodata means..
please..
After creating composite key , it is better to use autonumber()
Autonumber is nothing but number representation for each unique key.
Always number search is better than String search.
@ !
Coming to mapping i am bringing the Lookup value(category) with respect to lookup field(Key)to other table.
After mapping , table will automatically drop
For better understanding see Mapping concept
ApplyMap('Final_Category',Key,'Nodata') as Category
Maps field Key in table 'Final_Category' and 'Final_Overview' and returns Category if category is not availabe then this will show category as 'Nodata'
here Final_Category table is considered as Mapping table with Keyword Mapping added to it.
thank you so much.. in Apply map you have used ApplyMap('Final_Category',Key,'NoData') no data menas for that composite key combination if there is no value it will be nodata. Am i correct ..
Yes.....In place of no data you can write anything
And also it is not mandatory to give
Thanks a lot saikishore...