Using information links and Excel information simultaneously
I have a table with added columns from multiple information links but when I try to add some columns from an excel spreadsheet, all of the new columns show up blank... I've tried it multiple times in different ways.. It is driving me crazy- does anyone know what the problem could be?
Agree with Sean that we need a sample. My guess is that the join between the IL data and what you want to add is the issue. You may be joining on to many columns so as to not have any matches. You could be joining columns of different data types etc. Sounds like the Excel data is not lining up with the other data. I have found lots of issues with data in Excel such as multiple spaces between words or a space before a word etc.
It depends on your data. Can you provide some sample data (perhaps a .dxp with the data embedded) and an excel file which shows this?