WDC not allowing appending data when union with XLSX

[suraj-converse]

I know that when we union 2 XLSX files, it allows us to append the data to those excel files. But I joined an XLSX file and WDC . Then it's not allowing me to append data to that XLSX file.

Is there any different approach that I can try where I have the option of appending and relation with WDC ??

[KeshiaRose]

Unfortunately, this feature is not available for WDCs.

[suraj-converse]

Thank you for your reply 👍. Is there any kind of workaround that I could do @KeshiaRose?

[KeshiaRose]

Hmm, it depends on the data you're working with. Do you have control of the WDC? If so can you add the data you need there? Alternatively, you may want to think about using another tool to bring the data in, perhaps the Hyper API. What kind of data are you working with, and where is it coming from?

[suraj-converse]

Yes, I have complete control over the WDC. In fact, I built it. It's an API that gets the data from our server. Another one is an excel file which I receive daily. I have refresh data in Tableau online daily.

Do you think hyper API will work for this?

[KeshiaRose]

Wonderful! Yes, I think you should try building a data source with the Hyper API, you'll be able to bring in data from multiple different sources into one extract. Take a look at the documentation and these samples to get started!

You could also try and stick with the WDC route and try to find a way to bring the Excel file in there, perhaps uploading it to something like Google Sheets first? Those are the two directions I would try out!