We have extended our Early Bird Tickets for Inspire 2023! Discounted pricing goes until February 24th. Save your spot!

Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer and Intelligence Suite.

how to resolve this issue: The Excel archive is corrupted: shared strings root=x:sst ??

stj1120
8 - Asteroid

Hi all,

 

I have an excel file with SAP BW Query in it. After the schedule refresh I take that file as an input to the Alteryx workflow. 

I'm getting some strange error in Dynamic Input tool as below. But, I'm able to open the excel file without any issues. 

 

Error: Dynamic Input (4) The Excel archive is corrupted: shared strings root=x:sst

 

stj1120_0-1668707106140.png

 

stj1120_0-1668708090046.png

 

Due to this, Sheet name is not showing as 'Sheet1$' in the Table or Query tab in the Dynamic Input tool. 

 

I cannot attach the file or the workflow as it is confidential.

 

Kindly check and help me with the solution.

 

Thanks and Best regards,

Teja.

3 REPLIES 3
gabrielvilella
14 - Magnetar

Try opening the Excel, save it and then read in Alteryx again.

wdavis
Alteryx
Alteryx

Hi @stj1120 

 

A couple of things just to clarify first;

 

  • From the Directory Tool are you just looking to take in one file? Or is it multiple?
  • Are you able to open that Excel file on it's own within Alteryx?

 

Can you test bringing in the excel file as a standard input, but selecting to read in a list of sheet names and then to also show full path as shown below. Then build the connection string to feed into the Dynamic Input

 

wdavis_0-1668770820640.png

wdavis_1-1668770873747.png

 

Let me know if that still populates the same error.

 

Thanks

Will

 

 

alexnajm
11 - Bolide

+1 on this issue. Dynamic Input does not resolve this issue :(

Labels