首页 \ 问答 \ sqlite版本的vlookup(sqlite version of vlookup)

sqlite版本的vlookup(sqlite version of vlookup)

有没有办法在sqlite中做一个相当于vlookup的方法? 我正在尝试这样的事情:主表:ValueA | ValueB | concatValueA&VALUEB

映射表:concatValueA和ValueB | 映射值

决赛桌:ValueA | ValueB | concatValueA和ValueB | 映射值

在Excel中,我只是做一个vlookup。

有没有办法将映射值添加到sqlite中的表?

我试过这个:

UPDATE Master Set "mapped Value" = (select mapping."mapped Value" from Master left join mapping on Master.concat = mapping.concat)

但是这个填充将映射的Value列设置为完全等于select语句中的第一个值,但我希望这些值不同


is there a way in sqlite to do the equivalent of a vlookup? I'm trying to do something like this: Master table: ValueA | ValueB | concatValueA&ValueB

Mapping table: concatValueA&ValueB | mapped Value

final table: ValueA | ValueB | concatValueA&ValueB | mapped Value

In Excel, I would just do a vlookup.

Is there a way to add the mapped value to a table in sqlite?

I tried this:

UPDATE Master Set "mapped Value" = (select mapping."mapped Value" from Master left join mapping on Master.concat = mapping.concat)

But this fills sets the mapped Value column entirely equal to the first value from the select statement, but I would like the values to be different


原文:https://stackoverflow.com/questions/30109179
更新时间:2023-04-29 19:04

最满意答案

让我们假设你在UITableViewController中构建一个带有对象的数组(例如:MyObject.m / h)。 您应该使用didSelectRowAtIndexPath检测用户选择了哪个单元格,然后在准备segue时使用该整数从数组中检索MyObject。 例如:

- (void)tableView:(UITableView *)tableView didSelectRowAtIndexPath:(NSIndexPath *)indexPath{

        cellPressed =(int)indexPath.row; //cellPressed is an integer variable(global variable in my VC

        [self performSegueWithIdentifier:@"toMyVC" sender:self];

}

现在准备ForSegue:

- (void)prepareForSegue:(UIStoryboardSegue *)segue sender:(id)sender {

if([[segue identifier] isEqualToString:@"toMyVc"]){

    MyVC *mVC = [segue destinationViewController];
    mVC.myObject = [myArrayWithMyObjects objectAtIndex:cellPressed];

 }
}

在您的编辑视图中:

IDEditVC *secondViewController =
[storyBoard instantiateViewControllerWithIdentifier:@"editvc"];
secondViewController.myObj = myObjectRetrievedFromArray;

注意:您应该在.h文件中声明一个变量MyObject,以便从其他类可见。

在类中声明“全局”变量:

@interface ViewController : UIViewController{

  int cellPressed; //This is accessible by any method in YourViewController.m
}

Lets assume that in UITableViewController you are building the TableView an array with objects(eg: MyObject.m/h). You should detect which cell the user has select using the didSelectRowAtIndexPath and then retrieve MyObject from your array using that integer at prepare for segue. Eg:

- (void)tableView:(UITableView *)tableView didSelectRowAtIndexPath:(NSIndexPath *)indexPath{

        cellPressed =(int)indexPath.row; //cellPressed is an integer variable(global variable in my VC

        [self performSegueWithIdentifier:@"toMyVC" sender:self];

}

Now on prepareForSegue:

- (void)prepareForSegue:(UIStoryboardSegue *)segue sender:(id)sender {

if([[segue identifier] isEqualToString:@"toMyVc"]){

    MyVC *mVC = [segue destinationViewController];
    mVC.myObject = [myArrayWithMyObjects objectAtIndex:cellPressed];

 }
}

In your Edit View:

IDEditVC *secondViewController =
[storyBoard instantiateViewControllerWithIdentifier:@"editvc"];
secondViewController.myObj = myObjectRetrievedFromArray;

Note: You should declare a variable MyObject in .h file in order to be visible from other classes.

Declaring a "global" variable in a class:

@interface ViewController : UIViewController{

  int cellPressed; //This is accessible by any method in YourViewController.m
}

相关问答

更多

相关文章

更多

最新问答

更多
  • 获取MVC 4使用的DisplayMode后缀(Get the DisplayMode Suffix being used by MVC 4)
  • 如何通过引用返回对象?(How is returning an object by reference possible?)
  • 矩阵如何存储在内存中?(How are matrices stored in memory?)
  • 每个请求的Java新会话?(Java New Session For Each Request?)
  • css:浮动div中重叠的标题h1(css: overlapping headlines h1 in floated divs)
  • 无论图像如何,Caffe预测同一类(Caffe predicts same class regardless of image)
  • xcode语法颜色编码解释?(xcode syntax color coding explained?)
  • 在Access 2010 Runtime中使用Office 2000校对工具(Use Office 2000 proofing tools in Access 2010 Runtime)
  • 从单独的Web主机将图像传输到服务器上(Getting images onto server from separate web host)
  • 从旧版本复制文件并保留它们(旧/新版本)(Copy a file from old revision and keep both of them (old / new revision))
  • 西安哪有PLC可控制编程的培训
  • 在Entity Framework中选择基类(Select base class in Entity Framework)
  • 在Android中出现错误“数据集和渲染器应该不为null,并且应该具有相同数量的系列”(Error “Dataset and renderer should be not null and should have the same number of series” in Android)
  • 电脑二级VF有什么用
  • Datamapper Ruby如何添加Hook方法(Datamapper Ruby How to add Hook Method)
  • 金华英语角.
  • 手机软件如何制作
  • 用于Android webview中图像保存的上下文菜单(Context Menu for Image Saving in an Android webview)
  • 注意:未定义的偏移量:PHP(Notice: Undefined offset: PHP)
  • 如何读R中的大数据集[复制](How to read large dataset in R [duplicate])
  • Unity 5 Heighmap与地形宽度/地形长度的分辨率关系?(Unity 5 Heighmap Resolution relationship to terrain width / terrain length?)
  • 如何通知PipedOutputStream线程写入最后一个字节的PipedInputStream线程?(How to notify PipedInputStream thread that PipedOutputStream thread has written last byte?)
  • python的访问器方法有哪些
  • DeviceNetworkInformation:哪个是哪个?(DeviceNetworkInformation: Which is which?)
  • 在Ruby中对组合进行排序(Sorting a combination in Ruby)
  • 网站开发的流程?
  • 使用Zend Framework 2中的JOIN sql检索数据(Retrieve data using JOIN sql in Zend Framework 2)
  • 条带格式类型格式模式编号无法正常工作(Stripes format type format pattern number not working properly)
  • 透明度错误IE11(Transparency bug IE11)
  • linux的基本操作命令。。。