Hi Guys,
i am importing CSV table called "Table1.csv" into workook.
I have in workbook Table2 which i am merginf with Table1.
Table1 from CSV:
Col1Col2Col3
| 1 | 2 | 3 |
| 4 | 5 | 6 |
Table2 in workbook:
Col1Col2
| 1 | A |
| 4 | B |
And i am getting result in Merged worksheet (i am combining this 2 tables with inner join):
Col1Col2Table1.Col2Table1.Col3
| 1 | A | 2 | 3 |
| 4 | B | 5 | 6 |
It is working perfectly.
Problem is that source data will be removed or server where i have this data turn off. Table1 source will be not available for user!
And now if i want to get Merged result using refresh i am getting error
- Could not find file" C:/...." (file address in my computer).
Table1 was already imported once from CSV so i have already data inside workbook.
How can i fix the error not having CSV file source anymore?
Am i force to create another PQ table based on already imported source ? (imported Table1 data?)
Or there is another possibility to skip this?
Please help,
Jacek
Hi Jacek,
Yes, you need to create another PQ table based on the already imported source. There's no skipping this step, sorry.
Mynda
thank you Linda,
what about Try... otherwise clause? It could work?
Best,
Jacek
If you want the data retained from the deleted CSV file then you need to load it back into PQ based on the query output you have in the workbook. If you just want PQ to ignore the missing data then you can simply delete the query. I'm not seeing how try, otherwise will help.
Mynda
thank you!
