-
1. Re: Not showing sample values nor results for wildcard union
Nathan Panuco May 21, 2018 10:49 AM (in response to Olivia Shen)1 of 1 people found this helpfulI've had this happen when my columns didn't quite match up nicely within my CSVs. I went through each file and "copy/pasted" the header row from the first CSV and that fixed my issue. That may not be your exact problem, but potentially there's an issue with the data coming into Prep.
Try adding one file at a time to the wildcard union and see which one causes the data to disappear.
Also, Prep might still be churning away - have you opened Task Manager to see if CPU, Memory or Ethernet is maxed out?
-
2. Re: Not showing sample values nor results for wildcard union
Olivia Shen May 21, 2018 9:27 PM (in response to Nathan Panuco)1 of 1 people found this helpfulHi Nathan,
Thanks for the reply.
I've imported different files to test it and finally revealed that this issue was caused by brackets "[", "]" in my files names. Have no idea why it's not working, might have something to do with SharePoint as well. Anyway, after getting rid of the brackets, wildcard union works fine for all the data sources.