Forum Discussion
Solved
Gathering Field data from different table of same header fields
Hi Team, new to BI word, would liek to get some help on below item, I have two tables with same field names, need to add Table A filed information into Table B as per dates listed in table...
Hi Vemul ,
Based on my uderstanding i writing the below options,
1. you can use Reference option, if you would like to get replicate or get all the data from Table A to Table B and the Table B should be automatically updated whenever Table A gets updated,
2. When you have different in Table B and would like to pull data Table A as additional columns then you have to Merge Table A with Table B based on a common column between the two tables.
Please share the expected output in detail if you need to drive any particular result after Merging two tables.
HI Aburar,
Table A is manual entry and Table B is system driven, it need Table B capture data from Table A when ever it updates baed on date
hope this helps
V