根据类别和子类别评估表达式 [英] Evaluate expression based on category and sub category

问题描述

 

我需要为每个客户端创建一个基于类别和子类别的表达式，该表达式创建一个输出文件，其中一种格式为类别，另一种格式为sub_category  类别和子类别对于单个客户端都有自己的ID。 

I need to create an expression based on category and subcategory for a every client which creates an output files with one format for category and another format sub_category.  Category and sub category have their own ID's for a single client. 

我正在考虑创建一个布尔变量并基于此变量，我可以确定子类别是否评估为真。若是，那么我需要创建一个带有表达式的输出文件：  @ [User :: FolderPathSource] +" \\SubCAtegory_" + @ [User :: FileNameSource] +" .txt" 

I'm thinking in the lines of creating a boolean variable and based on this variable, I can determine if subcategory evaluates to true . if so then I need to create an output file with expression : @[User::FolderPathSource]+ "\\SubCAtegory_"+@[User::FileNameSource]+".txt" 

如果子类别为false，则表达式为：  @ [User :: FolderPathSource] +" \\Category_" + @ [User :: FileNameSource] +" .txt"  ;

If subcategory is false then expression would be: @[User::FolderPathSource]+ "\\Category_"+@[User::FileNameSource]+".txt" 

推荐答案

ISNULL  （@ [User :: SourceID]）？  （@ [User :: FolderPathSource] + @ [User :: LegacyReformattedFolder] +" \\Converted_" + @ [User :: FileNameSource]）:( @ [User :: FolderPathSource] + @ [User :: LegacyReformattedFolder ] +" \\" + @ [User :: SourceCode] +" _Converted"
@ [User :: FileNameSource]） 

ISNULL  ( @[User::SourceID] ) ?  (@[User::FolderPathSource]+ @[User::LegacyReformattedFolder]+"\\Converted_"+ @[User::FileNameSource] ) : (@[User::FolderPathSource]+ @[User::LegacyReformattedFolder]+"\\"+@[User::SourceCode]+"_Converted" @[User::FileNameSource]) 

可以任意一个让我知道上述案例陈述有什么问题。我无法弄清楚.. 

can any one let me know what is wrong with above case statement. I could not figure this out.. 

这篇关于根据类别和子类别评估表达式的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！