This content has been marked as final. Show 3 replies
>>My target is to eliminate 'N/A' and repalce with 'NO'.
Do you want to keep same columns and rows?
Maybe you want to try this:
Map: Mapping LOAD * Inline [ From, To N/A, NO ]; MAP Q1,Q2,Q3 using Map; SOURCE: LOAD Q1, Q2, Q3 FROM [https://community.qlik.com/servlet/JiveServlet/download/1135616-248083/SURVEY.xlsx] (ooxml, embedded labels, table is Sheet2);