如何了解excel公式?(将其转换为sql查询) [英] how to understand excel formulas?( To convert it to sql query)
问题描述
我看到的主要问题是使用的各种excel公式的可读性有困难,粘贴一个这样的样本,
有关如何解码这些公式的任何帮助建议将是有帮助的。另一个问题 - 是否有一种将vlookup的公式转换为sql查询的可行方法?
= IF(ISERROR(FIND(6000301407, @ [快照销售到Cust Id]])),IF(ISERROR(FIND(6003921231,[@ [Snapshot Sold To Cust Id]])),IF(ISERROR(FIND(6001089085,[@ [Snapshot Sold To Cust Id] ])),IF(ISERROR(FIND(6011995534,[@ [Snapshot Sold To Cust Id]])),IF(ISERROR(FIND(FID(6008725372,[@ [Snapshot Sell To Cust Id]])),IF(ISERROR FIND(6013991835,[@ [快照销售到Cust Id]])),VLOOKUP([@快照销往行业密钥Dsc]],Licensee_List [#All],2,0),否),是 ),否),否),否),否)
看起来你的公式试图找到这些数字值(从 60 ...
开始),字符串值称为 [@ [Snapshot Sold To Cust Id]]
。流程如下所示:
搜索[@ [快照销售到Cust Id]]:
找到6000301407?打印否。
Else
找到6003921231?打印否。
Else
发现6001089085?打印是。
Else
发现6011995534?打印否。
Else
发现6008725372?打印是。
Else
发现6013991835?打印否。
Else
搜索[@ [快照销往行业密钥Dsc]]在Licensee_List [#All]并输出右下角的值。
I have some complex Excel formulas which I plan to convert to oracle/sql as part of an automation process, The main problem i see is the difficulty in the readablilty of various excel formulas that are used, pasting one such sample here, Any help suggestion on how to decode these formulas will be helpful. The other question- is there a feasible way to convert formulas involving vlookup to a sql query?
=IF(ISERROR(FIND(6000301407,[@[Snapshot Sold To Cust Id]])),IF(ISERROR(FIND(6003921231,[@[Snapshot Sold To Cust Id]])),IF(ISERROR(FIND(6001089085,[@[Snapshot Sold To Cust Id]])),IF(ISERROR(FIND(6011995534,[@[Snapshot Sold To Cust Id]])),IF(ISERROR(FIND(6008725372,[@[Snapshot Sold To Cust Id]])),IF(ISERROR(FIND(6013991835,[@[Snapshot Sold To Cust Id]])),VLOOKUP([@[Snapshot Sold To Industry Key Dsc]],Licensee_List[#All],2,0),"No"),"Yes"),"No"),"Yes"),"No"),"No")
Looks like your formula tries to find those numeric values (starting with 60...
) in string value called [@[Snapshot Sold To Cust Id]]
. The flow is like following:
Search in [@[Snapshot Sold To Cust Id]]:
Found 6000301407? Print "No".
Else
Found 6003921231? Print "No".
Else
Found 6001089085? Print "Yes".
Else
Found 6011995534? Print "No".
Else
Found 6008725372? Print "Yes".
Else
Found 6013991835? Print "No".
Else
Search [@[Snapshot Sold To Industry Key Dsc]] In Licensee_List[#All] And Output The Value In Next Column To The Right.
这篇关于如何了解excel公式?(将其转换为sql查询)的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!