Forum Discussion
download in one query
Hi deniztopcu ,
I have simplified the queries. see the attached solution.
The challenge was the layout to get the rename part to work dynamically.
I create an input table and turn the transformation query to fx.
I hope it helps you and put you in the position for your priority matrix.
Regards
KT
Hi deniztopcu ,
Would you mind explaining a bit more about your desired outcome? (i.e. your end goal)
My understanding is:
1. You have a SYMBOL and URL list,
2. You scrubbing off the Balance Sheet from the web,
3. Up to the current step, we have the Balance Sheet. Are you saying that you want to use the template "Bos Bilanco" and turn it into a financial matrix (i.e. the working capital, liquidation ratio and such?)
Regards
KT
- I updated my excel example. As in the example, I want to see the result that I have obtained by combining the simple "senexx" queries. your example is of course a solution but I will need to rearrange this data.
- My first expectation is to get the following table in one query.
this is my priority.matrix will be my next mission
Regards
Hi deniztopcu ,
I have simplified the queries. see the attached solution.
The challenge was the layout to get the rename part to work dynamically.
I create an input table and turn the transformation query to fx.
I hope it helps you and put you in the position for your priority matrix.
Regards
KT