Forum Discussion
Need help in importing data from web. Conditional formatting not working on imported data
I am importing data from this link -
https://www.nseindia.com/live_market/dynaContent/live_watch/option_chain/optionKeys.jsp?symbolCode=-10006&symbol=NIFTY&symbol=NIFTY&instrument=-&date=-&segmentLink=17&symbolCount=2&segmentLink=17
After loading of the table, I am applying conditional formatting to get data bars. But I am getting data bars in only one column (Column named Strike pice). In all the other columns the formatting is not working.
9 Replies
Check the datatype of other columns. They seem to have Text datatype. Edit your query and change the datatype to numeric datatype i.e. Whole Number or Decimals and it should word as expected.
Tried it. But the problem still persists.
That's since all such columns most probably are formatted as text. If you replace all "-" on nothing or zero, and convert the rest to numbers, conditional formatting shall work on columns with numbers.
Tried it. But the problem still persists. This was not the problem in office 2010 & 2013.
I tried that with legacy Web connector which returns numbers, not texts. Data bar conditional formatting works on returned result.
If use Power Query by default it converts these columns to text. If not Load but Transform and add couple of more steps - apply Decimal Number type to these columns and Replace all errors on nulls, it works as well.
