Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Experts,
I am facing a problem to integrate a table in existing data model.
I have a fact table in datamodel having one of field as Location which i am using as filter in Front End.
Eg:
Consider below is the table which i want to integrate in the existing Datamodel.
PID | CID | Location | Pprice |
P1001 | C1001 | HYD|CHE|BNG | 100 |
P1002 | C1002 | HYD | 150 |
P1001 | C1003 | PUN|KER | 222 |
P1002 | C1002 | GOA | 300 |
P1004 | C1004 | MUM|RAJ | 90 |
In Data model , Location Field has values like...
Location |
HYD |
CHE |
BNG |
KER |
PUN |
GOA |
MUM |
RAJ |
SO first record should get highlighted when location is selected as HYD or CHE or BNG in Front end.
similarly for other records.
Please help me on this.
Thanks in advance 🙂